package com.gxan.service;

import com.gxan.pojo.Training;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

//培训管理service
public interface TrainingService{
    //查询所有培训计划
    List<Training> findTrainingAll(Integer page,Integer limit) throws SQLException;
    //新增培训计划
    int addTraining(Training training) throws SQLException;
    //查询总条数
    Integer countTraining() throws SQLException;
    //修改培训计划
    int updateTraining(Training training) throws SQLException;
    //根据id删除培训计划
    int deleteTrainingById(Integer training_id) throws SQLException;
    //按条件搜索
    List<Training> searchTrainings(Integer page, Integer limit, String training_name, String audit_status, String start_time, String end_time) throws SQLException;
    //查询搜索的总条数
    int countTrainingByParams(String training_name, String audit_status, String start_time, String end_time) throws SQLException;
    //修改审核状态====通过审核
    int checkTraining(Training training) throws SQLException;
    //修改审核状态====驳回
    int rejectTraining(Training training) throws SQLException;
    //添加培训计划与反馈
    int feedbackAddTraining(Training training) throws SQLException;
}
